SELECT *, CASE WHEN `name` LIKE "washington%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "washington" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "washington" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "washington" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "DC" AND (locality IN ("washington") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 34
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "DC" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 34
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$31,900,0002400 Foxhall Rd NWWashington DC 20007View Listing
$14,900,0002509 Foxhall Rd NWWashington DC 20007View Listing
$14,500,0002040 S St NWWashington DC 20009View Listing
$14,250,0002425 Foxhall Rd NWWashington DC 20007View Listing
$13,950,0002727 Q St NWWashington DC 20007View Listing
$13,500,0002815 Woodland Dr NWWashington DC 20008View Listing
$10,500,0003005 45th St NWWashington DC 20016View Listing
$10,000,0003101 Chain Bridge Rd NWWashington DC 20016View Listing
$9,995,0003131 Chain Bridge Rd NWWashington DC 20016View Listing
$9,888,0001908 24th St NWWashington DC 20008View Listing
$8,995,0002438 Belmont Rd NWWashington DC 20008View Listing
$7,500,0001816 Jefferson Pl NWWashington DC 20036View Listing
$6,850,0001633 31st St NWWashington DC 20007View Listing
$6,825,0003065 University Ter NWWashington DC 20016View Listing
$6,500,0002211 Massachusetts Ave NWWashington DC 20008View Listing
$6,500,0001832 24th St NWWashington DC 20008View Listing
$6,490,0002601 Foxhall Rd NWWashington DC 20007View Listing
$5,999,0005030 Linnean Ave NWWashington DC 20008View Listing
$5,950,0003024 44th St NWWashington DC 20016View Listing
$5,900,0003246 S St NWWashington DC 20007View Listing
$5,880,0001352 28th St NWWashington DC 20007View Listing
$5,850,0005050 Linnean Ave NWWashington DC 20008View Listing
$5,250,0002703 Dumbarton St NWWashington DC 20007View Listing
$5,100,0004435 Cathedral Ave NWWashington DC 20016View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 3:07:34 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "DC" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 34
Blah